Using Set Fixed Prices

Select EXIT to return to the Sales menu.

1. At the Item field, enter the item group and item code of the item whose fixed price exception needs to be changed.

If you are uncertain of the item code, see Navigating Net Yield - Selecting an Item Code.

2. The following information will display:

• Item Mask – The item maskA mask is used to conduct a wild card search. Visually a mask is represented by a series of forward slash marks (///), sometimes with a letter, letters, or number(s) preceding it (1/// or AB///). For example, if you enter ////////, this indicates that you want to list all items defined in the system. If you enter in 1//1//1/, this indicates that you want the system to list items that have the digit "1" in those locations. that contains the item selected in Step #1
• Cust Mask – The customer that currently has a fixed price exception assigned to the item selected in Step #1
• Prx Cls – The price class that currently has a fixed price exception
• Ship Days MTWTFSS – The days of the week the for which the fixed price exception applies
• Description – The name, or description, of the fixed price exception
• Amount – The fixed price exception amount, in dollars.

 

Command options will appear:

• Change – Select Change to change the amount of the fixed price exception.
  • Scroll down the Amount field and make the appropriate changes.
  • Use the Page Down, Tab, Enter, or arrow keys to move through the remaining fields.
  • Select Update to save changes.
• Update – Select Update to save any changes made to the fixed price exception.
• Exit – Select Exit to return to the Item field.

 

1. At the Customer field, enter the customer code for the customer whose fixed prices need to be changed.

2. A Select An Option window will display with the following options:

• EXIT – Select EXIT to exit and return to the Select An Option window.
• ALL FIXED PRICE ITEMS – Select ALL FIXED PRICE ITEMS to make changes to all fixed price items. Select one of the following costs to use to calculate the new fixed price, using the same tools available in Set Selling Prices. A Select An Option window will appear with the following options:
  • Actual Cost – Select Actual Cost to change the fixed price to the actual cost, if applicable.
  • Last Completed PO Cost – Select Last Completed PO Cost to use the last price paid plus any add-on costs for the last completed purchase order. See Cost Adjustments - value-type adjustments and Set Selling Price for more information.
  • Higher of Actual/Last PO – Select Higher of Actual/Last PO to change the fixed price to whichever value is higher – the actual cost or the cost of the last completed purchase order.
  • Standard Cost – Select Standard Cost to change the fixed price to the user defined standard cost, if applicable.
  • Incoming PO – Select Incoming PO to change the fixed price to the cost of the next incoming purchase order.

See Set Selling Price for more information on how to set selling prices.

 

Note: If fixed price items are not found for the customer selected the Fixed Price Items selection box will be empty.

 

• ALL PRICE SHEET ITEMS – Select ALL PRICE SHEET ITEMS to make changes to the selling price for items on the customer's price sheet items using the same tools available in Set Selling Prices. See Price Sheet Setup.
• Actual Cost – Select Actual Cost to change the fixed price to the actual cost, if applicable.
• Last Completed PO Cost – Select Last Completed PO Cost to change the fixed price to the cost of the last completed purchase order.
• Higher of Actual/Last PO – Select Higher of Actual/Last PO to change the fixed price to whichever value is higher – the actual cost or the cost of the last completed purchase order.
• Standard Cost – Select Standard Cost to change the fixed price to the standard cost, if applicable.
• Incoming PO – Select Incoming PO to change the fixed price to the cost of the last incoming purchase order.

See Set Selling Prices for more information on how to set selling prices.

 

Note: If ALL PRICE SHEET ITEMS is selected, upon updating, a fixed price exception will be created for the customer selected.

Scroll to the appropriate selections. A Fixed Price Item table will display with the following columns:

• Item – The item name
• Cost – The cost for the item based on the cost type selected above
• Unit – The invoicing unit of measure
• Markup – The current markup type selected. See Markup (below).
• Price – The current fixed price
• Profit – The current per unit profit based on the current fixed price minus the cost type selected
• Margin – The gross margin percent based on the current fixed price minus the cost type selected.

 

Scroll down the Price column and enter the new fixed price for the item(s). The profit and margin numbers will be restated as you change the fixed price. Press F10 when finished and select Update or press F10 to calculate the fixed price.

Command options will appear regardless of your selection. These are the same options found in Set Selling Prices. See Set Selling Prices for more information.

• Change – Select Change to edit the base selling price.
• Cost – Select Cost to calculate the base selling price using the cost that you previously selected. See Set Selling Prices for more information.
• Markup – Select Markup to select which Item Markup 1-4 to use and apply the selected markup to the cost selected above. See Set Selling Prices for more information.
• Price+ – Select Price+ to apply a fixed price per unit amount or percentage to the selected base price. See Set Selling Prices for more information.
• Date – Select Date to enter the date to stop applying the fixed price. A Fixed Price Item Details table will display with the following information:
• Item – The item name
• Cost – The cost for the item based on the cost type selected above
• Unit – The invoicing unit of measure
• Markup – The current markup type selected. See Markup above.
• Price – The current fixed price
• Item – The item name
• Stop Date – The current stop date used to stop applying the fixed price.

Scroll down the Stop Date column and enter the new stop date. To save the changes, press F10 to display command options and select Update.

• • Change – Select Change to go back to the Fixed Price Item Details table above and enter the new stop dates.
  • Current Date + (S) – Select Current Date + S to reset the stop date to the current stop date plus XX number of days. Enter the number of days to add to the current stop date in the Days field and press Enter. Or, press Enter without entering a number to return to the command options.
  • Today + – Select Today + to reset the stop date to today’s date plus XX number of days. Enter the number of days to add to today's date in the Days field and press Enter. Or, press Enter without entering a number to return to the command options.
  • Exit – Select Exit to exit the Date command option and return to the Fixed Price Item table. Press F10 to return to the first set of command options.
  Zero – Select Zero to zero all base selling prices. See Set Selling Prices for more information.
• Update – Select Update to update and save the base selling price changes.

Important: Your changes will not be saved unless you select Update.

• Print(X) – Select Print(X) to print a price report. Command options will appear:
  • Price Report – Select Price Report to print a price report. See Printing a Price Report for more information.
  • Exit – Select Exit to exit without printing a price report and return to the command options.
• Exit – Select Exit to exit and return to the Customer field.